﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace PropertyManagementSystemAPI.Models {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "warrantyadd", DisableSyncStructure = true)]
	public partial class Warrantyadd {

		/// <summary>
		/// 小区所处位置
		/// </summary>
		[JsonProperty]
		public string CellAddress { get; set; }

		/// <summary>
		/// 小区面积
		/// </summary>
		[JsonProperty]
		public double? CellArea { get; set; }

		/// <summary>
		/// 小区所在市
		/// </summary>
		[JsonProperty]
		public string CellCity { get; set; }

		/// <summary>
		/// 小区创建时间
		/// </summary>
		[JsonProperty]
		public DateTime? CellCreateTime { get; set; }

		/// <summary>
		/// 小区开发商
		/// </summary>
		[JsonProperty]
		public string CellDevelopers { get; set; }

		/// <summary>
		/// 小区绿化率
		/// </summary>
		[JsonProperty]
		public double? CellGreening { get; set; }

		/// <summary>
		/// 小区总户数
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? CellHousehold { get; set; }

		/// <summary>
		/// 小区编号，主键自增
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int CellId { get; set; }

		/// <summary>
		/// 小区缩略图
		/// </summary>
		[JsonProperty]
		public string CellImg { get; set; }

		/// <summary>
		/// 小区名称
		/// </summary>
		[JsonProperty]
		public string CellName { get; set; }

		/// <summary>
		/// 小区所属物业
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? CellProperty { get; set; }

		/// <summary>
		/// 小区物业公司名
		/// </summary>
		[JsonProperty]
		public string CellPropertyCompany { get; set; }

		/// <summary>
		/// 小区所在省
		/// </summary>
		[JsonProperty]
		public string CellProvince { get; set; }

		/// <summary>
		/// 小区状态(0不显示，1显示)
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? CellState { get; set; }

		/// <summary>
		/// 用户创建时间
		/// </summary>
		[JsonProperty]
		public DateTime? UserCreateTime { get; set; }

		/// <summary>
		/// 用户邮箱
		/// </summary>
		[JsonProperty]
		public string UserEmail { get; set; }

		/// <summary>
		/// 用户编号（主键）
		/// </summary>
		[JsonProperty, Column(DbType = "int unsigned")]
		public uint UserId { get; set; }

		/// <summary>
		/// 用户身份（外键）
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int UserIdentity { get; set; }

		/// <summary>
		/// 用户头像
		/// </summary>
		[JsonProperty]
		public string UserImg { get; set; }

		/// <summary>
		/// 用户名
		/// </summary>
		[JsonProperty]
		public string UserName { get; set; }

		/// <summary>
		/// 用户密码
		/// </summary>
		[JsonProperty]
		public string UserPassword { get; set; }

		/// <summary>
		/// 用户状态(0未启用，1启用)
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? UserState { get; set; }

		/// <summary>
		/// 用户电话
		/// </summary>
		[JsonProperty]
		public string UserTelephone { get; set; }

		/// <summary>
		/// 申请状态（0未撤销，1撤销）
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? WApplication { get; set; }

		/// <summary>
		/// 评价等级（1-5）
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? WAssess { get; set; }

		/// <summary>
		/// 所属小区
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? WCellId { get; set; }

		/// <summary>
		/// 申请时间
		/// </summary>
		[JsonProperty]
		public DateTime? WCreateTime { get; set; }

		/// <summary>
		/// 受理时间
		/// </summary>
		[JsonProperty]
		public DateTime? WEndTime { get; set; }

		/// <summary>
		/// 保修设备
		/// </summary>
		[JsonProperty]
		public string WEquipment { get; set; }

		/// <summary>
		/// 保修编号，主键
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int WId { get; set; }

		/// <summary>
		/// 备注
		/// </summary>
		[JsonProperty]
		public string WRemark { get; set; }

		/// <summary>
		/// 受理状态(0未受理，1受理)
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? WState { get; set; }

		/// <summary>
		/// 保修描述
		/// </summary>
		[JsonProperty]
		public string WText { get; set; }

		/// <summary>
		/// 报修用户编号
		/// </summary>
		[JsonProperty, Column(DbType = "int")]
		public int? WUserId { get; set; }

	}

}
